<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Restoring One or Multiple Tables in a Hive Backup Set">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="hive_00049.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
<meta name="DC.Publisher" content="20241029">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="hive_00052">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Restoring One or Multiple Tables in a Hive Backup Set</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="hive_00052"></a><a name="hive_00052"></a>

<h1 class="topictitle1">Restoring One or Multiple Tables in a Hive Backup Set</h1>
<div><p>This section describes how to restore one or more tables in a Hive backup set.</p>
<div class="section"><h4 class="sectiontitle">Context</h4><p>Data can be restored using a backup copy or an archive copy. Table-level restoration is not supported using an archive copy of a replication copy or using a copy archived to a tape library. Restoration to the original or a new location is supported.</p>
</div>
<div class="section"><h4 class="sectiontitle">Prerequisites</h4><p id="hive_00052__hive_00051_p16881165611516">During the backup set restoration, ensure that the registered user of the target cluster has been authorized to operate Hive database tables and the <strong id="hive_00052__hive_00051_b197061032143715">Location</strong> directory where the table data files reside.</p>
</div>
<div class="section"><h4 class="sectiontitle">Procedure</h4><ol><li><span>Choose <span class="uicontrol" id="hive_00052__hive_00048_en-us_topic_0000001839142377_uicontrol11751516495"><b><span id="hive_00052__hive_00048_en-us_topic_0000001839142377_text1817513544919"><strong>Explore</strong></span> &gt; <span id="hive_00052__hive_00048_en-us_topic_0000001839142377_text141754534916"><strong>Copy Data</strong></span> &gt; <span id="hive_00052__hive_00048_en-us_topic_0000001839142377_text6965202616539"><strong>Big Data</strong></span> &gt; Hive</b></span>.</span></li><li><span>You can search for copies by Hive backup set resource or copy. This section describes how to search for copies by resource.</span><p><p>On the <strong>Resources</strong> tab page, locate the backup set to be restored based on the backup set name and click the backup set name.</p>
</p></li><li><span>Click the <span class="uicontrol"><b><span><strong>Copy Data</strong></span></b></span> tab page and select the year, month, and day in sequence to locate the copy.</span><p><p>If <span><img src="en-us_image_0000001839160645.png"></span> is displayed below a month or day, a copy is generated in that month or day.</p>
</p></li><li><span>In the row where the copy resides, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Table-level Restoration</strong></span></b></span>.</span></li><li><span>In the left pane of the <span class="uicontrol"><b><span><strong>Table-level Restoration</strong></span></b></span> page, select the table to be restored.</span></li><li><span>On the right of the <span class="uicontrol"><b><span><strong>Table-level Restoration</strong></span></b></span> page, click <span class="uicontrol"><b><span><strong>Please select</strong></span></b></span> and select the target location to which you want to restore data.</span><p><div class="p"><a href="#hive_00052__table175551511133610">Table 1</a> describes related parameters.
<div class="tablenoborder"><a name="hive_00052__table175551511133610"></a><a name="table175551511133610"></a><table cellpadding="4" cellspacing="0" summary="" id="hive_00052__table175551511133610" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Selecting a target location for restoration</caption><colgroup><col style="width:23.09%"><col style="width:76.91%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="23.09%" id="mcps1.3.4.2.6.2.1.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="76.91%" id="mcps1.3.4.2.6.2.1.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="23.09%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.1 "><p><span><strong>Restore To</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="76.91%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.2 "><p>Restore the file to the original location or a new location.</p>
<ul><li><span><strong>Original location</strong></span>: Restore the backup set to the original Hive cluster.</li><li><span><strong>New location</strong></span>: Restore the backup set to a new location. You need to specify the target Hive cluster.</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="23.09%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.1 "><p><span><strong>Target Cluster</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="76.91%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.2 "><p>When restoring the backup set to a new location, you need to specify the target Hive cluster.</p>
<div class="note"><span class="notetitle"> NOTE: </span><div class="notebody"><p>Encrypted Hive tables cannot be restored to a new location.</p>
</div></div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="23.09%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.1 "><p><strong>Metadata storage path</strong></p>
</td>
<td class="cellrowborder" valign="top" width="76.91%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.2 "><p>Select a path for storing metadata.</p>
<p>This path is used to temporarily store table metadata. After the restoration is complete, the stored metadata is automatically deleted.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="23.09%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.1 "><p><strong>Table Overwriting Rule</strong></p>
</td>
<td class="cellrowborder" valign="top" width="76.91%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.2 "><p>If a table with the same name exists in the restoration path, you can select either of the following:</p>
<ul><li><span><strong>Ignore the existing table</strong></span>: Tables with the same names are skipped and are not replaced.</li><li><span><strong>Replace the existing table</strong></span></li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="23.09%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.1 "><p><strong>Table Data File Overwriting Rule</strong></p>
<p></p>
</td>
<td class="cellrowborder" valign="top" width="76.91%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.2 "><p>You can choose to delete or retain all data files in the location during the restoration.</p>
<ul><li><strong>Delete existing table data files</strong></li><li><strong>Retain existing table data files</strong></li></ul>
<p>The option <strong>Delete existing table data files</strong> is selected by default. If the locations of multiple tables are the same, you are advised to select <strong>Retain existing table data files</strong> and select a data storage path for the table to be restored. Otherwise, all data files in the location will be deleted during the restoration.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="23.09%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.1 "><p><strong>Table Data Storage Path</strong></p>
</td>
<td class="cellrowborder" valign="top" width="76.91%" headers="mcps1.3.4.2.6.2.1.2.2.3.1.2 "><p>When <strong>Table Data File Overwriting Rule</strong> is set to <strong>Retain existing table data files</strong>, select a data storage path for the table to be restored.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</p></li><li><span>Click <span class="uicontrol"><b>OK</b></span>.</span></li></ol>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="hive_00049.html">Restoration</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>